package pers.bc.utils.constant;
/**
 * *
 * Created with Description:
 *
 * @version 1.0 <br>
 * @packagename: com.xisoft.hr.utils.constant<br>
 * @author: LiBencheng <br>
 * @computer: licheng <br>
 * @date: Created on 2022/11/1 16:10 <br>
 */
public interface ImporCons
{

    // ======================================================
    /**
     * 根据主表ID查询详表信息  SELECT * FROM sys_excel_config_details WHERE EXCEL_CONFIG_ID=${excel_config_id}  ORDER BY
     * field_code asc
     */
    String QUERYEXCELDETAILSBYID = "queryExcelDetailsById";
    /** 根据code查询主表信息 \n SELECT * FROM sys_excel_config WHERE EXCEL_CONFIG_CODE=${excel_config_code} */
    String QUERYEXCELCONFIGBYCODE = "queryExcelConfigByCode";

    // ======================================================
    String SALARY_GRANT_PRESENT = "SALARY_GRANT_PRESENT";

    String BUSINESS_TYPE_CODE = "business_type_code";
    /** 对照方式 1工号2工号+姓名3身份证号4身份证号+姓名 */
    String CONTRAST = "contrast";
    String NUM = "num";
    String COL = "col";
    String ITME_PRO = "ITME_PRO";
    String LISTMAP = "listMap";
    String COLNAMELIST = "colNameList";
    String COLUMN_NAME = "column_name";

    /**  */
    String EXCEL_CONFIG_ID = "excel_config_id";
    /**  */
    String EXCEL_CONFIG_CODE = "excel_config_code";
    /** 导入sheet页名字 解析的时候用的 */
    String EXCEL_CONFIG_SHEET_NAME = "excel_config_sheet_name";
    /**  */
    String TYPE = "type";
    String DATATYPE = "datatype";
    String DATA_TYPE = "data_type";
    String ID = "id";
    /** 导入方式 新增，覆盖，跳过 */
    String DEDUPLICATION = "deduplication";

    /** 需要导入的列 */
    String GRANTDATALIST = "grantDataList";
    /** 配置列+动态列 */
    String DYNAMICCOL = "dynamicCol";
    /** 系统 */
    String TARGET_SYSTEM = "target_system";
    /** 表 */
    String TARGET_SYSTEM_TABLE = "target_system_table";
    /** 前端手动录入的sheet名称 */
    String NEW_EXCELSHEETNAME = "new_excelSheetName";
    String BATCH_FIELD_NAME = "batch_field_name";
    String SHEETNAME = "sheetname";
    String SHEET = "sheet";
    String ISDIRTY = "isdirty";
    String CONTRAST_MODE = "contrast_mode";
    String ERROR_COLUMN_MAP = "errorColumnMap";
    String ERROR_COLUMN_LIST = "errorColumnList";

    //******************************************************************
    String NEWPERIOD = "newperiod";
    String PERSION_NAME = "persion_name";
    String PERSION_CODE = "persion_code";
    String PERSION_ID_NUMBER = "persion_id_number";
    String CODENAME = "codename";
    String IDCARDNAME = "idcardname";
    String INDEX = "operate_index";

    String PERSON_CODE = "person_code";
    String PERSON_ID = "person_id"; 
    String BATCH = "batch";
    String FATHERPK = "fatherpk";
    
}
